%%{init: {'themeVariables': { 'fontSize': '12px'}}}%%
graph TD
    classDef path fill:#eee,stroke:#000,color:#000
    classDef plan fill:#fff,stroke-width:1px,color:#000
    classDef itemplan fill:#fff,stroke-width:2px,color:#000
    classDef unbatchedplan fill:#dff,stroke-width:1px,color:#000
    classDef sideeffectplan fill:#fcc,stroke-width:2px,color:#000
    classDef bucket fill:#f6f6f6,color:#000,stroke-width:2px,text-align:left

    subgraph "Buckets for queries/v4/pg11.network_types"
    Bucket0("Bucket 0 (root)<br /><br />1: <br />ᐳ: 6, 11, 12, 145, 146, 147, 148, 7, 13, 15, 17, 23, 25, 31, 33, 39<br />2: 10, 20, 28, 36, 45, 50, 55, 60<br />ᐳ: 86, 89, 92, 95<br />3: 14, 22, 30, 38, 47, 52, 57, 62<br />ᐳ: 46, 48, 49, 51, 53, 54, 56, 58, 59, 61, 63, 64<br />4: 65, 68, 71, 74<br />ᐳ: 85, 87, 88, 90, 91, 93, 94, 96, 97, 98, 99, 100, 101, 102, 103, 104"):::bucket
    Bucket1("Bucket 1 (nullableBoundary)<br />Deps: 14, 86, 65, 49, 87, 98<br /><br />ROOT Connectionᐸ10ᐳ[14]"):::bucket
    Bucket2("Bucket 2 (nullableBoundary)<br />Deps: 22, 89, 68, 54, 90, 100<br /><br />ROOT Connectionᐸ20ᐳ[22]"):::bucket
    Bucket3("Bucket 3 (nullableBoundary)<br />Deps: 30, 92, 71, 59, 93, 102<br /><br />ROOT Connectionᐸ28ᐳ[30]"):::bucket
    Bucket4("Bucket 4 (nullableBoundary)<br />Deps: 38, 95, 74, 64, 96, 104<br /><br />ROOT Connectionᐸ36ᐳ[38]"):::bucket
    Bucket9("Bucket 9 (listItem)<br />Deps: 86<br /><br />ROOT __Item{9}ᐸ65ᐳ[77]"):::bucket
    Bucket10("Bucket 10 (listItem)<br />Deps: 89<br /><br />ROOT __Item{10}ᐸ68ᐳ[79]"):::bucket
    Bucket11("Bucket 11 (listItem)<br />Deps: 92<br /><br />ROOT __Item{11}ᐸ71ᐳ[81]"):::bucket
    Bucket12("Bucket 12 (listItem)<br />Deps: 95<br /><br />ROOT __Item{12}ᐸ74ᐳ[83]"):::bucket
    Bucket13("Bucket 13 (nullableBoundary)<br />Deps: 77, 78, 114<br /><br />ROOT Edge{9}[78]"):::bucket
    Bucket14("Bucket 14 (nullableBoundary)<br />Deps: 79, 80, 116<br /><br />ROOT Edge{10}[80]"):::bucket
    Bucket15("Bucket 15 (nullableBoundary)<br />Deps: 81, 82, 118<br /><br />ROOT Edge{11}[82]"):::bucket
    Bucket16("Bucket 16 (nullableBoundary)<br />Deps: 83, 84, 120<br /><br />ROOT Edge{12}[84]"):::bucket
    Bucket17("Bucket 17 (nullableBoundary)<br />Deps: 121<br /><br />ROOT PgSelectSingle{13}ᐸnetworkᐳ[121]"):::bucket
    Bucket18("Bucket 18 (nullableBoundary)<br />Deps: 122<br /><br />ROOT PgSelectSingle{14}ᐸnetworkᐳ[122]"):::bucket
    Bucket19("Bucket 19 (nullableBoundary)<br />Deps: 123<br /><br />ROOT PgSelectSingle{15}ᐸnetworkᐳ[123]"):::bucket
    Bucket20("Bucket 20 (nullableBoundary)<br />Deps: 124<br /><br />ROOT PgSelectSingle{16}ᐸnetworkᐳ[124]"):::bucket
    end
    Bucket0 --> Bucket1 & Bucket2 & Bucket3 & Bucket4
    Bucket1 --> Bucket9
    Bucket2 --> Bucket10
    Bucket3 --> Bucket11
    Bucket4 --> Bucket12
    Bucket9 --> Bucket13
    Bucket10 --> Bucket14
    Bucket11 --> Bucket15
    Bucket12 --> Bucket16
    Bucket13 --> Bucket17
    Bucket14 --> Bucket18
    Bucket15 --> Bucket19
    Bucket16 --> Bucket20

    %% plan dependencies
    __InputObject7{{"__InputObject[7∈0] ➊<br />More deps:<br />- Constantᐸundefinedᐳ[6]<br />- Constantᐸ'192.168.0.0'ᐳ[145]"}}:::plan
    PgSelect10[["PgSelect[10∈0] ➊<br />ᐸnetwork+1ᐳ"]]:::plan
    Object13{{"Object[13∈0] ➊<br />ᐸ{pgSettings,withPgClient}ᐳ"}}:::plan
    ApplyInput15{{"ApplyInput[15∈0] ➊"}}:::plan
    Object13 & ApplyInput15 --> PgSelect10
    Access11{{"Access[11∈0] ➊<br />ᐸ2.pgSettingsᐳ"}}:::plan
    Access12{{"Access[12∈0] ➊<br />ᐸ2.withPgClientᐳ"}}:::plan
    Access11 & Access12 --> Object13
    __InputObject17{{"__InputObject[17∈0] ➊<br />More deps:<br />- Constantᐸundefinedᐳ[6]<br />- Constantᐸ'192.168.0.0/16'ᐳ[146]"}}:::plan
    PgSelect20[["PgSelect[20∈0] ➊<br />ᐸnetwork+1ᐳ"]]:::plan
    ApplyInput23{{"ApplyInput[23∈0] ➊"}}:::plan
    Object13 & ApplyInput23 --> PgSelect20
    __InputObject25{{"__InputObject[25∈0] ➊<br />More deps:<br />- Constantᐸundefinedᐳ[6]<br />- Constantᐸ'08:00:2b:01:02:03'ᐳ[147]"}}:::plan
    PgSelect28[["PgSelect[28∈0] ➊<br />ᐸnetwork+1ᐳ"]]:::plan
    ApplyInput31{{"ApplyInput[31∈0] ➊"}}:::plan
    Object13 & ApplyInput31 --> PgSelect28
    __InputObject33{{"__InputObject[33∈0] ➊<br />More deps:<br />- Constantᐸundefinedᐳ[6]<br />- Constantᐸ'08:00:2b:01:02:03:04:05'ᐳ[148]"}}:::plan
    PgSelect36[["PgSelect[36∈0] ➊<br />ᐸnetwork+1ᐳ"]]:::plan
    ApplyInput39{{"ApplyInput[39∈0] ➊"}}:::plan
    Object13 & ApplyInput39 --> PgSelect36
    PgSelect45[["PgSelect[45∈0] ➊<br />ᐸnetwork(aggregate)ᐳ"]]:::plan
    Object13 & ApplyInput15 --> PgSelect45
    PgSelect50[["PgSelect[50∈0] ➊<br />ᐸnetwork(aggregate)ᐳ"]]:::plan
    Object13 & ApplyInput23 --> PgSelect50
    PgSelect55[["PgSelect[55∈0] ➊<br />ᐸnetwork(aggregate)ᐳ"]]:::plan
    Object13 & ApplyInput31 --> PgSelect55
    PgSelect60[["PgSelect[60∈0] ➊<br />ᐸnetwork(aggregate)ᐳ"]]:::plan
    Object13 & ApplyInput39 --> PgSelect60
    __Value2["__Value[2∈0] ➊<br />ᐸcontextᐳ"]:::plan
    __Value2 --> Access11
    __Value2 --> Access12
    Connection14[["Connection[14∈0] ➊<br />ᐸ10ᐳ<br />Dependents: 4"]]:::plan
    PgSelect10 --> Connection14
    __InputObject7 --> ApplyInput15
    Connection22[["Connection[22∈0] ➊<br />ᐸ20ᐳ<br />Dependents: 4"]]:::plan
    PgSelect20 --> Connection22
    __InputObject17 --> ApplyInput23
    Connection30[["Connection[30∈0] ➊<br />ᐸ28ᐳ<br />Dependents: 4"]]:::plan
    PgSelect28 --> Connection30
    __InputObject25 --> ApplyInput31
    Connection38[["Connection[38∈0] ➊<br />ᐸ36ᐳ<br />Dependents: 4"]]:::plan
    PgSelect36 --> Connection38
    __InputObject33 --> ApplyInput39
    First46{{"First[46∈0] ➊"}}:::plan
    PgSelectRows47[["PgSelectRows[47∈0] ➊"]]:::plan
    PgSelectRows47 --> First46
    PgSelect45 --> PgSelectRows47
    PgSelectSingle48{{"PgSelectSingle[48∈0] ➊<br />ᐸnetworkᐳ"}}:::plan
    First46 --> PgSelectSingle48
    First51{{"First[51∈0] ➊"}}:::plan
    PgSelectRows52[["PgSelectRows[52∈0] ➊"]]:::plan
    PgSelectRows52 --> First51
    PgSelect50 --> PgSelectRows52
    PgSelectSingle53{{"PgSelectSingle[53∈0] ➊<br />ᐸnetworkᐳ"}}:::plan
    First51 --> PgSelectSingle53
    First56{{"First[56∈0] ➊"}}:::plan
    PgSelectRows57[["PgSelectRows[57∈0] ➊"]]:::plan
    PgSelectRows57 --> First56
    PgSelect55 --> PgSelectRows57
    PgSelectSingle58{{"PgSelectSingle[58∈0] ➊<br />ᐸnetworkᐳ"}}:::plan
    First56 --> PgSelectSingle58
    First61{{"First[61∈0] ➊"}}:::plan
    PgSelectRows62[["PgSelectRows[62∈0] ➊"]]:::plan
    PgSelectRows62 --> First61
    PgSelect60 --> PgSelectRows62
    PgSelectSingle63{{"PgSelectSingle[63∈0] ➊<br />ᐸnetworkᐳ"}}:::plan
    First61 --> PgSelectSingle63
    ConnectionItems65[["ConnectionItems[65∈0] ➊<br />Dependents: 3<br />More deps:<br />- Connection[14]"]]:::plan
    ConnectionItems68[["ConnectionItems[68∈0] ➊<br />Dependents: 3<br />More deps:<br />- Connection[22]"]]:::plan
    ConnectionItems71[["ConnectionItems[71∈0] ➊<br />Dependents: 3<br />More deps:<br />- Connection[30]"]]:::plan
    ConnectionItems74[["ConnectionItems[74∈0] ➊<br />Dependents: 3<br />More deps:<br />- Connection[38]"]]:::plan
    First85{{"First[85∈0] ➊<br />More deps:<br />- ConnectionItems[65]"}}:::plan
    Access86{{"Access[86∈0] ➊<br />ᐸ10.cursorDetailsᐳ<br />Dependents: 3"}}:::plan
    PgSelect10 --> Access86
    First88{{"First[88∈0] ➊<br />More deps:<br />- ConnectionItems[68]"}}:::plan
    Access89{{"Access[89∈0] ➊<br />ᐸ20.cursorDetailsᐳ<br />Dependents: 3"}}:::plan
    PgSelect20 --> Access89
    First91{{"First[91∈0] ➊<br />More deps:<br />- ConnectionItems[71]"}}:::plan
    Access92{{"Access[92∈0] ➊<br />ᐸ28.cursorDetailsᐳ<br />Dependents: 3"}}:::plan
    PgSelect28 --> Access92
    First94{{"First[94∈0] ➊<br />More deps:<br />- ConnectionItems[74]"}}:::plan
    Access95{{"Access[95∈0] ➊<br />ᐸ36.cursorDetailsᐳ<br />Dependents: 3"}}:::plan
    PgSelect36 --> Access95
    Last97{{"Last[97∈0] ➊<br />More deps:<br />- ConnectionItems[65]"}}:::plan
    Last99{{"Last[99∈0] ➊<br />More deps:<br />- ConnectionItems[68]"}}:::plan
    Last101{{"Last[101∈0] ➊<br />More deps:<br />- ConnectionItems[71]"}}:::plan
    Last103{{"Last[103∈0] ➊<br />More deps:<br />- ConnectionItems[74]"}}:::plan
    PageInfo41{{"PageInfo[41∈1] ➊<br />More deps:<br />- Connection[14]"}}:::plan
    Access105{{"Access[105∈1] ➊<br />ᐸ14.hasNextPageᐳ<br />More deps:<br />- Connection[14]"}}:::plan
    Access109{{"Access[109∈1] ➊<br />ᐸ14.hasPreviousPageᐳ<br />More deps:<br />- Connection[14]"}}:::plan
    PageInfo42{{"PageInfo[42∈2] ➊<br />More deps:<br />- Connection[22]"}}:::plan
    Access106{{"Access[106∈2] ➊<br />ᐸ22.hasNextPageᐳ<br />More deps:<br />- Connection[22]"}}:::plan
    Access110{{"Access[110∈2] ➊<br />ᐸ22.hasPreviousPageᐳ<br />More deps:<br />- Connection[22]"}}:::plan
    PageInfo43{{"PageInfo[43∈3] ➊<br />More deps:<br />- Connection[30]"}}:::plan
    Access107{{"Access[107∈3] ➊<br />ᐸ30.hasNextPageᐳ<br />More deps:<br />- Connection[30]"}}:::plan
    Access111{{"Access[111∈3] ➊<br />ᐸ30.hasPreviousPageᐳ<br />More deps:<br />- Connection[30]"}}:::plan
    PageInfo44{{"PageInfo[44∈4] ➊<br />More deps:<br />- Connection[38]"}}:::plan
    Access108{{"Access[108∈4] ➊<br />ᐸ38.hasNextPageᐳ<br />More deps:<br />- Connection[38]"}}:::plan
    Access112{{"Access[112∈4] ➊<br />ᐸ38.hasPreviousPageᐳ<br />More deps:<br />- Connection[38]"}}:::plan
    Edge78{{"Edge[78∈9]"}}:::plan
    __Item77[/"__Item[77∈9]<br />ᐸ65ᐳ<br />More deps:<br />- ConnectionItems[65]"\]:::itemplan
    PgCursor114{{"PgCursor[114∈9]<br />More deps:<br />- Access[86]"}}:::plan
    __Item77 & PgCursor114 --> Edge78
    __Item77 --> PgCursor114
    Edge80{{"Edge[80∈10]"}}:::plan
    __Item79[/"__Item[79∈10]<br />ᐸ68ᐳ<br />More deps:<br />- ConnectionItems[68]"\]:::itemplan
    PgCursor116{{"PgCursor[116∈10]<br />More deps:<br />- Access[89]"}}:::plan
    __Item79 & PgCursor116 --> Edge80
    __Item79 --> PgCursor116
    Edge82{{"Edge[82∈11]"}}:::plan
    __Item81[/"__Item[81∈11]<br />ᐸ71ᐳ<br />More deps:<br />- ConnectionItems[71]"\]:::itemplan
    PgCursor118{{"PgCursor[118∈11]<br />More deps:<br />- Access[92]"}}:::plan
    __Item81 & PgCursor118 --> Edge82
    __Item81 --> PgCursor118
    Edge84{{"Edge[84∈12]"}}:::plan
    __Item83[/"__Item[83∈12]<br />ᐸ74ᐳ<br />More deps:<br />- ConnectionItems[74]"\]:::itemplan
    PgCursor120{{"PgCursor[120∈12]<br />More deps:<br />- Access[95]"}}:::plan
    __Item83 & PgCursor120 --> Edge84
    __Item83 --> PgCursor120
    PgSelectSingle121{{"PgSelectSingle[121∈13]<br />ᐸnetworkᐳ"}}:::plan
    __Item77 --> PgSelectSingle121
    PgSelectSingle122{{"PgSelectSingle[122∈14]<br />ᐸnetworkᐳ"}}:::plan
    __Item79 --> PgSelectSingle122
    PgSelectSingle123{{"PgSelectSingle[123∈15]<br />ᐸnetworkᐳ"}}:::plan
    __Item81 --> PgSelectSingle123
    PgSelectSingle124{{"PgSelectSingle[124∈16]<br />ᐸnetworkᐳ"}}:::plan
    __Item83 --> PgSelectSingle124
    PgClassExpression125{{"PgClassExpression[125∈17]<br />ᐸ__network__.”id”ᐳ"}}:::plan
    PgSelectSingle121 --> PgClassExpression125
    PgClassExpression129{{"PgClassExpression[129∈17]<br />ᐸ__network__.”inet”ᐳ"}}:::plan
    PgClassExpression125 o--o PgClassExpression129
    PgClassExpression133{{"PgClassExpression[133∈17]<br />ᐸ__network__.”cidr”ᐳ"}}:::plan
    PgClassExpression129 o--o PgClassExpression133
    PgClassExpression137{{"PgClassExpression[137∈17]<br />ᐸ__network__.”macaddr”ᐳ"}}:::plan
    PgClassExpression133 o--o PgClassExpression137
    PgClassExpression141{{"PgClassExpression[141∈17]<br />ᐸ__network__.”macaddr8”ᐳ"}}:::plan
    PgClassExpression137 o--o PgClassExpression141
    PgClassExpression126{{"PgClassExpression[126∈18]<br />ᐸ__network__.”id”ᐳ"}}:::plan
    PgSelectSingle122 --> PgClassExpression126
    PgClassExpression130{{"PgClassExpression[130∈18]<br />ᐸ__network__.”inet”ᐳ"}}:::plan
    PgClassExpression126 o--o PgClassExpression130
    PgClassExpression134{{"PgClassExpression[134∈18]<br />ᐸ__network__.”cidr”ᐳ"}}:::plan
    PgClassExpression130 o--o PgClassExpression134
    PgClassExpression138{{"PgClassExpression[138∈18]<br />ᐸ__network__.”macaddr”ᐳ"}}:::plan
    PgClassExpression134 o--o PgClassExpression138
    PgClassExpression142{{"PgClassExpression[142∈18]<br />ᐸ__network__.”macaddr8”ᐳ"}}:::plan
    PgClassExpression138 o--o PgClassExpression142
    PgClassExpression127{{"PgClassExpression[127∈19]<br />ᐸ__network__.”id”ᐳ"}}:::plan
    PgSelectSingle123 --> PgClassExpression127
    PgClassExpression131{{"PgClassExpression[131∈19]<br />ᐸ__network__.”inet”ᐳ"}}:::plan
    PgClassExpression127 o--o PgClassExpression131
    PgClassExpression135{{"PgClassExpression[135∈19]<br />ᐸ__network__.”cidr”ᐳ"}}:::plan
    PgClassExpression131 o--o PgClassExpression135
    PgClassExpression139{{"PgClassExpression[139∈19]<br />ᐸ__network__.”macaddr”ᐳ"}}:::plan
    PgClassExpression135 o--o PgClassExpression139
    PgClassExpression143{{"PgClassExpression[143∈19]<br />ᐸ__network__.”macaddr8”ᐳ"}}:::plan
    PgClassExpression139 o--o PgClassExpression143
    PgClassExpression128{{"PgClassExpression[128∈20]<br />ᐸ__network__.”id”ᐳ"}}:::plan
    PgSelectSingle124 --> PgClassExpression128
    PgClassExpression132{{"PgClassExpression[132∈20]<br />ᐸ__network__.”inet”ᐳ"}}:::plan
    PgClassExpression128 o--o PgClassExpression132
    PgClassExpression136{{"PgClassExpression[136∈20]<br />ᐸ__network__.”cidr”ᐳ"}}:::plan
    PgClassExpression132 o--o PgClassExpression136
    PgClassExpression140{{"PgClassExpression[140∈20]<br />ᐸ__network__.”macaddr”ᐳ"}}:::plan
    PgClassExpression136 o--o PgClassExpression140
    PgClassExpression144{{"PgClassExpression[144∈20]<br />ᐸ__network__.”macaddr8”ᐳ"}}:::plan
    PgClassExpression140 o--o PgClassExpression144

    %% define steps
    classDef bucket0 stroke:#696969
    class Bucket0,__Value2,__InputObject7,PgSelect10,Access11,Access12,Object13,Connection14,ApplyInput15,__InputObject17,PgSelect20,Connection22,ApplyInput23,__InputObject25,PgSelect28,Connection30,ApplyInput31,__InputObject33,PgSelect36,Connection38,ApplyInput39,PgSelect45,First46,PgSelectRows47,PgSelectSingle48,PgSelect50,First51,PgSelectRows52,PgSelectSingle53,PgSelect55,First56,PgSelectRows57,PgSelectSingle58,PgSelect60,First61,PgSelectRows62,PgSelectSingle63,ConnectionItems65,ConnectionItems68,ConnectionItems71,ConnectionItems74,First85,Access86,First88,Access89,First91,Access92,First94,Access95,Last97,Last99,Last101,Last103 bucket0
    classDef bucket1 stroke:#00bfff
    class Bucket1,PageInfo41,Access105,Access109 bucket1
    classDef bucket2 stroke:#7f007f
    class Bucket2,PageInfo42,Access106,Access110 bucket2
    classDef bucket3 stroke:#ffa500
    class Bucket3,PageInfo43,Access107,Access111 bucket3
    classDef bucket4 stroke:#0000ff
    class Bucket4,PageInfo44,Access108,Access112 bucket4
    classDef bucket9 stroke:#ff0000
    class Bucket9,__Item77,Edge78,PgCursor114 bucket9
    classDef bucket10 stroke:#ffff00
    class Bucket10,__Item79,Edge80,PgCursor116 bucket10
    classDef bucket11 stroke:#00ffff
    class Bucket11,__Item81,Edge82,PgCursor118 bucket11
    classDef bucket12 stroke:#4169e1
    class Bucket12,__Item83,Edge84,PgCursor120 bucket12
    classDef bucket13 stroke:#3cb371
    class Bucket13,PgSelectSingle121 bucket13
    classDef bucket14 stroke:#a52a2a
    class Bucket14,PgSelectSingle122 bucket14
    classDef bucket15 stroke:#ff00ff
    class Bucket15,PgSelectSingle123 bucket15
    classDef bucket16 stroke:#f5deb3
    class Bucket16,PgSelectSingle124 bucket16
    classDef bucket17 stroke:#696969
    class Bucket17,PgClassExpression125,PgClassExpression129,PgClassExpression133,PgClassExpression137,PgClassExpression141 bucket17
    classDef bucket18 stroke:#00bfff
    class Bucket18,PgClassExpression126,PgClassExpression130,PgClassExpression134,PgClassExpression138,PgClassExpression142 bucket18
    classDef bucket19 stroke:#7f007f
    class Bucket19,PgClassExpression127,PgClassExpression131,PgClassExpression135,PgClassExpression139,PgClassExpression143 bucket19
    classDef bucket20 stroke:#ffa500
    class Bucket20,PgClassExpression128,PgClassExpression132,PgClassExpression136,PgClassExpression140,PgClassExpression144 bucket20

